package com.ttj.domain.oracle.gen;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderInstockCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    public OrderInstockCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andInIdIsNull() {
            addCriterion("IN_ID is null");
            return (Criteria) this;
        }

        public Criteria andInIdIsNotNull() {
            addCriterion("IN_ID is not null");
            return (Criteria) this;
        }

        public Criteria andInIdEqualTo(Integer value) {
            addCriterion("IN_ID =", value, "inId");
            return (Criteria) this;
        }

        public Criteria andInIdNotEqualTo(Integer value) {
            addCriterion("IN_ID <>", value, "inId");
            return (Criteria) this;
        }

        public Criteria andInIdGreaterThan(Integer value) {
            addCriterion("IN_ID >", value, "inId");
            return (Criteria) this;
        }

        public Criteria andInIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("IN_ID >=", value, "inId");
            return (Criteria) this;
        }

        public Criteria andInIdLessThan(Integer value) {
            addCriterion("IN_ID <", value, "inId");
            return (Criteria) this;
        }

        public Criteria andInIdLessThanOrEqualTo(Integer value) {
            addCriterion("IN_ID <=", value, "inId");
            return (Criteria) this;
        }

        public Criteria andInIdIn(List<Integer> values) {
            addCriterion("IN_ID in", values, "inId");
            return (Criteria) this;
        }

        public Criteria andInIdNotIn(List<Integer> values) {
            addCriterion("IN_ID not in", values, "inId");
            return (Criteria) this;
        }

        public Criteria andInIdBetween(Integer value1, Integer value2) {
            addCriterion("IN_ID between", value1, value2, "inId");
            return (Criteria) this;
        }

        public Criteria andInIdNotBetween(Integer value1, Integer value2) {
            addCriterion("IN_ID not between", value1, value2, "inId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("ORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("ORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("ORDER_ID =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("ORDER_ID <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("ORDER_ID >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ORDER_ID >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("ORDER_ID <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("ORDER_ID <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("ORDER_ID in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("ORDER_ID not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_ID between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_ID not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOIndateIsNull() {
            addCriterion("O_INDATE is null");
            return (Criteria) this;
        }

        public Criteria andOIndateIsNotNull() {
            addCriterion("O_INDATE is not null");
            return (Criteria) this;
        }

        public Criteria andOIndateEqualTo(Date value) {
            addCriterion("O_INDATE =", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotEqualTo(Date value) {
            addCriterion("O_INDATE <>", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateGreaterThan(Date value) {
            addCriterion("O_INDATE >", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateGreaterThanOrEqualTo(Date value) {
            addCriterion("O_INDATE >=", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateLessThan(Date value) {
            addCriterion("O_INDATE <", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateLessThanOrEqualTo(Date value) {
            addCriterion("O_INDATE <=", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateIn(List<Date> values) {
            addCriterion("O_INDATE in", values, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotIn(List<Date> values) {
            addCriterion("O_INDATE not in", values, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateBetween(Date value1, Date value2) {
            addCriterion("O_INDATE between", value1, value2, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotBetween(Date value1, Date value2) {
            addCriterion("O_INDATE not between", value1, value2, "oIndate");
            return (Criteria) this;
        }

        public Criteria andCreaterIsNull() {
            addCriterion("CREATER is null");
            return (Criteria) this;
        }

        public Criteria andCreaterIsNotNull() {
            addCriterion("CREATER is not null");
            return (Criteria) this;
        }

        public Criteria andCreaterEqualTo(String value) {
            addCriterion("CREATER =", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterNotEqualTo(String value) {
            addCriterion("CREATER <>", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterGreaterThan(String value) {
            addCriterion("CREATER >", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterGreaterThanOrEqualTo(String value) {
            addCriterion("CREATER >=", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterLessThan(String value) {
            addCriterion("CREATER <", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterLessThanOrEqualTo(String value) {
            addCriterion("CREATER <=", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterLike(String value) {
            addCriterion("CREATER like", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterNotLike(String value) {
            addCriterion("CREATER not like", value, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterIn(List<String> values) {
            addCriterion("CREATER in", values, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterNotIn(List<String> values) {
            addCriterion("CREATER not in", values, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterBetween(String value1, String value2) {
            addCriterion("CREATER between", value1, value2, "creater");
            return (Criteria) this;
        }

        public Criteria andCreaterNotBetween(String value1, String value2) {
            addCriterion("CREATER not between", value1, value2, "creater");
            return (Criteria) this;
        }

        public Criteria andDoneDateIsNull() {
            addCriterion("DONE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andDoneDateIsNotNull() {
            addCriterion("DONE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andDoneDateEqualTo(Date value) {
            addCriterion("DONE_DATE =", value, "doneDate");
            return (Criteria) this;
        }

        public Criteria andDoneDateNotEqualTo(Date value) {
            addCriterion("DONE_DATE <>", value, "doneDate");
            return (Criteria) this;
        }

        public Criteria andDoneDateGreaterThan(Date value) {
            addCriterion("DONE_DATE >", value, "doneDate");
            return (Criteria) this;
        }

        public Criteria andDoneDateGreaterThanOrEqualTo(Date value) {
            addCriterion("DONE_DATE >=", value, "doneDate");
            return (Criteria) this;
        }

        public Criteria andDoneDateLessThan(Date value) {
            addCriterion("DONE_DATE <", value, "doneDate");
            return (Criteria) this;
        }

        public Criteria andDoneDateLessThanOrEqualTo(Date value) {
            addCriterion("DONE_DATE <=", value, "doneDate");
            return (Criteria) this;
        }

        public Criteria andDoneDateIn(List<Date> values) {
            addCriterion("DONE_DATE in", values, "doneDate");
            return (Criteria) this;
        }

        public Criteria andDoneDateNotIn(List<Date> values) {
            addCriterion("DONE_DATE not in", values, "doneDate");
            return (Criteria) this;
        }

        public Criteria andDoneDateBetween(Date value1, Date value2) {
            addCriterion("DONE_DATE between", value1, value2, "doneDate");
            return (Criteria) this;
        }

        public Criteria andDoneDateNotBetween(Date value1, Date value2) {
            addCriterion("DONE_DATE not between", value1, value2, "doneDate");
            return (Criteria) this;
        }

        public Criteria andOStatusIsNull() {
            addCriterion("O_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andOStatusIsNotNull() {
            addCriterion("O_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andOStatusEqualTo(Integer value) {
            addCriterion("O_STATUS =", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusNotEqualTo(Integer value) {
            addCriterion("O_STATUS <>", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusGreaterThan(Integer value) {
            addCriterion("O_STATUS >", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("O_STATUS >=", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusLessThan(Integer value) {
            addCriterion("O_STATUS <", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusLessThanOrEqualTo(Integer value) {
            addCriterion("O_STATUS <=", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusIn(List<Integer> values) {
            addCriterion("O_STATUS in", values, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusNotIn(List<Integer> values) {
            addCriterion("O_STATUS not in", values, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusBetween(Integer value1, Integer value2) {
            addCriterion("O_STATUS between", value1, value2, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("O_STATUS not between", value1, value2, "oStatus");
            return (Criteria) this;
        }

        public Criteria andCidIsNull() {
            addCriterion("CID is null");
            return (Criteria) this;
        }

        public Criteria andCidIsNotNull() {
            addCriterion("CID is not null");
            return (Criteria) this;
        }

        public Criteria andCidEqualTo(Integer value) {
            addCriterion("CID =", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotEqualTo(Integer value) {
            addCriterion("CID <>", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThan(Integer value) {
            addCriterion("CID >", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThanOrEqualTo(Integer value) {
            addCriterion("CID >=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThan(Integer value) {
            addCriterion("CID <", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThanOrEqualTo(Integer value) {
            addCriterion("CID <=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidIn(List<Integer> values) {
            addCriterion("CID in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotIn(List<Integer> values) {
            addCriterion("CID not in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidBetween(Integer value1, Integer value2) {
            addCriterion("CID between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotBetween(Integer value1, Integer value2) {
            addCriterion("CID not between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCextIdIsNull() {
            addCriterion("CEXT_ID is null");
            return (Criteria) this;
        }

        public Criteria andCextIdIsNotNull() {
            addCriterion("CEXT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCextIdEqualTo(Integer value) {
            addCriterion("CEXT_ID =", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotEqualTo(Integer value) {
            addCriterion("CEXT_ID <>", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdGreaterThan(Integer value) {
            addCriterion("CEXT_ID >", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CEXT_ID >=", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdLessThan(Integer value) {
            addCriterion("CEXT_ID <", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdLessThanOrEqualTo(Integer value) {
            addCriterion("CEXT_ID <=", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdIn(List<Integer> values) {
            addCriterion("CEXT_ID in", values, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotIn(List<Integer> values) {
            addCriterion("CEXT_ID not in", values, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdBetween(Integer value1, Integer value2) {
            addCriterion("CEXT_ID between", value1, value2, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CEXT_ID not between", value1, value2, "cextId");
            return (Criteria) this;
        }

        public Criteria andCpersonIsNull() {
            addCriterion("CPERSON is null");
            return (Criteria) this;
        }

        public Criteria andCpersonIsNotNull() {
            addCriterion("CPERSON is not null");
            return (Criteria) this;
        }

        public Criteria andCpersonEqualTo(String value) {
            addCriterion("CPERSON =", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotEqualTo(String value) {
            addCriterion("CPERSON <>", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonGreaterThan(String value) {
            addCriterion("CPERSON >", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonGreaterThanOrEqualTo(String value) {
            addCriterion("CPERSON >=", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLessThan(String value) {
            addCriterion("CPERSON <", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLessThanOrEqualTo(String value) {
            addCriterion("CPERSON <=", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLike(String value) {
            addCriterion("CPERSON like", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotLike(String value) {
            addCriterion("CPERSON not like", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonIn(List<String> values) {
            addCriterion("CPERSON in", values, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotIn(List<String> values) {
            addCriterion("CPERSON not in", values, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonBetween(String value1, String value2) {
            addCriterion("CPERSON between", value1, value2, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotBetween(String value1, String value2) {
            addCriterion("CPERSON not between", value1, value2, "cperson");
            return (Criteria) this;
        }

        public Criteria andCphoneIsNull() {
            addCriterion("CPHONE is null");
            return (Criteria) this;
        }

        public Criteria andCphoneIsNotNull() {
            addCriterion("CPHONE is not null");
            return (Criteria) this;
        }

        public Criteria andCphoneEqualTo(String value) {
            addCriterion("CPHONE =", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotEqualTo(String value) {
            addCriterion("CPHONE <>", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneGreaterThan(String value) {
            addCriterion("CPHONE >", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneGreaterThanOrEqualTo(String value) {
            addCriterion("CPHONE >=", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLessThan(String value) {
            addCriterion("CPHONE <", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLessThanOrEqualTo(String value) {
            addCriterion("CPHONE <=", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLike(String value) {
            addCriterion("CPHONE like", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotLike(String value) {
            addCriterion("CPHONE not like", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneIn(List<String> values) {
            addCriterion("CPHONE in", values, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotIn(List<String> values) {
            addCriterion("CPHONE not in", values, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneBetween(String value1, String value2) {
            addCriterion("CPHONE between", value1, value2, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotBetween(String value1, String value2) {
            addCriterion("CPHONE not between", value1, value2, "cphone");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("TYPE =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("TYPE <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("TYPE >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("TYPE >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("TYPE <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("TYPE <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("TYPE in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("TYPE not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("TYPE between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("TYPE not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andLTypeIsNull() {
            addCriterion("L_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andLTypeIsNotNull() {
            addCriterion("L_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andLTypeEqualTo(Integer value) {
            addCriterion("L_TYPE =", value, "lType");
            return (Criteria) this;
        }

        public Criteria andLTypeNotEqualTo(Integer value) {
            addCriterion("L_TYPE <>", value, "lType");
            return (Criteria) this;
        }

        public Criteria andLTypeGreaterThan(Integer value) {
            addCriterion("L_TYPE >", value, "lType");
            return (Criteria) this;
        }

        public Criteria andLTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("L_TYPE >=", value, "lType");
            return (Criteria) this;
        }

        public Criteria andLTypeLessThan(Integer value) {
            addCriterion("L_TYPE <", value, "lType");
            return (Criteria) this;
        }

        public Criteria andLTypeLessThanOrEqualTo(Integer value) {
            addCriterion("L_TYPE <=", value, "lType");
            return (Criteria) this;
        }

        public Criteria andLTypeIn(List<Integer> values) {
            addCriterion("L_TYPE in", values, "lType");
            return (Criteria) this;
        }

        public Criteria andLTypeNotIn(List<Integer> values) {
            addCriterion("L_TYPE not in", values, "lType");
            return (Criteria) this;
        }

        public Criteria andLTypeBetween(Integer value1, Integer value2) {
            addCriterion("L_TYPE between", value1, value2, "lType");
            return (Criteria) this;
        }

        public Criteria andLTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("L_TYPE not between", value1, value2, "lType");
            return (Criteria) this;
        }

        public Criteria andSidIsNull() {
            addCriterion("SID is null");
            return (Criteria) this;
        }

        public Criteria andSidIsNotNull() {
            addCriterion("SID is not null");
            return (Criteria) this;
        }

        public Criteria andSidEqualTo(Integer value) {
            addCriterion("SID =", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidNotEqualTo(Integer value) {
            addCriterion("SID <>", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidGreaterThan(Integer value) {
            addCriterion("SID >", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidGreaterThanOrEqualTo(Integer value) {
            addCriterion("SID >=", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidLessThan(Integer value) {
            addCriterion("SID <", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidLessThanOrEqualTo(Integer value) {
            addCriterion("SID <=", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidIn(List<Integer> values) {
            addCriterion("SID in", values, "sid");
            return (Criteria) this;
        }

        public Criteria andSidNotIn(List<Integer> values) {
            addCriterion("SID not in", values, "sid");
            return (Criteria) this;
        }

        public Criteria andSidBetween(Integer value1, Integer value2) {
            addCriterion("SID between", value1, value2, "sid");
            return (Criteria) this;
        }

        public Criteria andSidNotBetween(Integer value1, Integer value2) {
            addCriterion("SID not between", value1, value2, "sid");
            return (Criteria) this;
        }

        public Criteria andPlateIsNull() {
            addCriterion("PLATE is null");
            return (Criteria) this;
        }

        public Criteria andPlateIsNotNull() {
            addCriterion("PLATE is not null");
            return (Criteria) this;
        }

        public Criteria andPlateEqualTo(String value) {
            addCriterion("PLATE =", value, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateNotEqualTo(String value) {
            addCriterion("PLATE <>", value, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateGreaterThan(String value) {
            addCriterion("PLATE >", value, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateGreaterThanOrEqualTo(String value) {
            addCriterion("PLATE >=", value, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateLessThan(String value) {
            addCriterion("PLATE <", value, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateLessThanOrEqualTo(String value) {
            addCriterion("PLATE <=", value, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateLike(String value) {
            addCriterion("PLATE like", value, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateNotLike(String value) {
            addCriterion("PLATE not like", value, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateIn(List<String> values) {
            addCriterion("PLATE in", values, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateNotIn(List<String> values) {
            addCriterion("PLATE not in", values, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateBetween(String value1, String value2) {
            addCriterion("PLATE between", value1, value2, "plate");
            return (Criteria) this;
        }

        public Criteria andPlateNotBetween(String value1, String value2) {
            addCriterion("PLATE not between", value1, value2, "plate");
            return (Criteria) this;
        }

        public Criteria andTimeTooutIsNull() {
            addCriterion("TIME_TOOUT is null");
            return (Criteria) this;
        }

        public Criteria andTimeTooutIsNotNull() {
            addCriterion("TIME_TOOUT is not null");
            return (Criteria) this;
        }

        public Criteria andTimeTooutEqualTo(Date value) {
            addCriterion("TIME_TOOUT =", value, "timeToout");
            return (Criteria) this;
        }

        public Criteria andTimeTooutNotEqualTo(Date value) {
            addCriterion("TIME_TOOUT <>", value, "timeToout");
            return (Criteria) this;
        }

        public Criteria andTimeTooutGreaterThan(Date value) {
            addCriterion("TIME_TOOUT >", value, "timeToout");
            return (Criteria) this;
        }

        public Criteria andTimeTooutGreaterThanOrEqualTo(Date value) {
            addCriterion("TIME_TOOUT >=", value, "timeToout");
            return (Criteria) this;
        }

        public Criteria andTimeTooutLessThan(Date value) {
            addCriterion("TIME_TOOUT <", value, "timeToout");
            return (Criteria) this;
        }

        public Criteria andTimeTooutLessThanOrEqualTo(Date value) {
            addCriterion("TIME_TOOUT <=", value, "timeToout");
            return (Criteria) this;
        }

        public Criteria andTimeTooutIn(List<Date> values) {
            addCriterion("TIME_TOOUT in", values, "timeToout");
            return (Criteria) this;
        }

        public Criteria andTimeTooutNotIn(List<Date> values) {
            addCriterion("TIME_TOOUT not in", values, "timeToout");
            return (Criteria) this;
        }

        public Criteria andTimeTooutBetween(Date value1, Date value2) {
            addCriterion("TIME_TOOUT between", value1, value2, "timeToout");
            return (Criteria) this;
        }

        public Criteria andTimeTooutNotBetween(Date value1, Date value2) {
            addCriterion("TIME_TOOUT not between", value1, value2, "timeToout");
            return (Criteria) this;
        }

        public Criteria andDriverIsNull() {
            addCriterion("DRIVER is null");
            return (Criteria) this;
        }

        public Criteria andDriverIsNotNull() {
            addCriterion("DRIVER is not null");
            return (Criteria) this;
        }

        public Criteria andDriverEqualTo(String value) {
            addCriterion("DRIVER =", value, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverNotEqualTo(String value) {
            addCriterion("DRIVER <>", value, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverGreaterThan(String value) {
            addCriterion("DRIVER >", value, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverGreaterThanOrEqualTo(String value) {
            addCriterion("DRIVER >=", value, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverLessThan(String value) {
            addCriterion("DRIVER <", value, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverLessThanOrEqualTo(String value) {
            addCriterion("DRIVER <=", value, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverLike(String value) {
            addCriterion("DRIVER like", value, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverNotLike(String value) {
            addCriterion("DRIVER not like", value, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverIn(List<String> values) {
            addCriterion("DRIVER in", values, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverNotIn(List<String> values) {
            addCriterion("DRIVER not in", values, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverBetween(String value1, String value2) {
            addCriterion("DRIVER between", value1, value2, "driver");
            return (Criteria) this;
        }

        public Criteria andDriverNotBetween(String value1, String value2) {
            addCriterion("DRIVER not between", value1, value2, "driver");
            return (Criteria) this;
        }

        public Criteria andAllocatDateIsNull() {
            addCriterion("ALLOCAT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andAllocatDateIsNotNull() {
            addCriterion("ALLOCAT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andAllocatDateEqualTo(Date value) {
            addCriterion("ALLOCAT_DATE =", value, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andAllocatDateNotEqualTo(Date value) {
            addCriterion("ALLOCAT_DATE <>", value, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andAllocatDateGreaterThan(Date value) {
            addCriterion("ALLOCAT_DATE >", value, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andAllocatDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ALLOCAT_DATE >=", value, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andAllocatDateLessThan(Date value) {
            addCriterion("ALLOCAT_DATE <", value, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andAllocatDateLessThanOrEqualTo(Date value) {
            addCriterion("ALLOCAT_DATE <=", value, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andAllocatDateIn(List<Date> values) {
            addCriterion("ALLOCAT_DATE in", values, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andAllocatDateNotIn(List<Date> values) {
            addCriterion("ALLOCAT_DATE not in", values, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andAllocatDateBetween(Date value1, Date value2) {
            addCriterion("ALLOCAT_DATE between", value1, value2, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andAllocatDateNotBetween(Date value1, Date value2) {
            addCriterion("ALLOCAT_DATE not between", value1, value2, "allocatDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIsNull() {
            addCriterion("DELIVERY_DATE is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIsNotNull() {
            addCriterion("DELIVERY_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateEqualTo(Date value) {
            addCriterion("DELIVERY_DATE =", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotEqualTo(Date value) {
            addCriterion("DELIVERY_DATE <>", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateGreaterThan(Date value) {
            addCriterion("DELIVERY_DATE >", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateGreaterThanOrEqualTo(Date value) {
            addCriterion("DELIVERY_DATE >=", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateLessThan(Date value) {
            addCriterion("DELIVERY_DATE <", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateLessThanOrEqualTo(Date value) {
            addCriterion("DELIVERY_DATE <=", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIn(List<Date> values) {
            addCriterion("DELIVERY_DATE in", values, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotIn(List<Date> values) {
            addCriterion("DELIVERY_DATE not in", values, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateBetween(Date value1, Date value2) {
            addCriterion("DELIVERY_DATE between", value1, value2, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotBetween(Date value1, Date value2) {
            addCriterion("DELIVERY_DATE not between", value1, value2, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andHangDateIsNull() {
            addCriterion("HANG_DATE is null");
            return (Criteria) this;
        }

        public Criteria andHangDateIsNotNull() {
            addCriterion("HANG_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andHangDateEqualTo(Date value) {
            addCriterion("HANG_DATE =", value, "hangDate");
            return (Criteria) this;
        }

        public Criteria andHangDateNotEqualTo(Date value) {
            addCriterion("HANG_DATE <>", value, "hangDate");
            return (Criteria) this;
        }

        public Criteria andHangDateGreaterThan(Date value) {
            addCriterion("HANG_DATE >", value, "hangDate");
            return (Criteria) this;
        }

        public Criteria andHangDateGreaterThanOrEqualTo(Date value) {
            addCriterion("HANG_DATE >=", value, "hangDate");
            return (Criteria) this;
        }

        public Criteria andHangDateLessThan(Date value) {
            addCriterion("HANG_DATE <", value, "hangDate");
            return (Criteria) this;
        }

        public Criteria andHangDateLessThanOrEqualTo(Date value) {
            addCriterion("HANG_DATE <=", value, "hangDate");
            return (Criteria) this;
        }

        public Criteria andHangDateIn(List<Date> values) {
            addCriterion("HANG_DATE in", values, "hangDate");
            return (Criteria) this;
        }

        public Criteria andHangDateNotIn(List<Date> values) {
            addCriterion("HANG_DATE not in", values, "hangDate");
            return (Criteria) this;
        }

        public Criteria andHangDateBetween(Date value1, Date value2) {
            addCriterion("HANG_DATE between", value1, value2, "hangDate");
            return (Criteria) this;
        }

        public Criteria andHangDateNotBetween(Date value1, Date value2) {
            addCriterion("HANG_DATE not between", value1, value2, "hangDate");
            return (Criteria) this;
        }

        public Criteria andModifTimeIsNull() {
            addCriterion("MODIF_TIME is null");
            return (Criteria) this;
        }

        public Criteria andModifTimeIsNotNull() {
            addCriterion("MODIF_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andModifTimeEqualTo(Date value) {
            addCriterion("MODIF_TIME =", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotEqualTo(Date value) {
            addCriterion("MODIF_TIME <>", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeGreaterThan(Date value) {
            addCriterion("MODIF_TIME >", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("MODIF_TIME >=", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeLessThan(Date value) {
            addCriterion("MODIF_TIME <", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeLessThanOrEqualTo(Date value) {
            addCriterion("MODIF_TIME <=", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeIn(List<Date> values) {
            addCriterion("MODIF_TIME in", values, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotIn(List<Date> values) {
            addCriterion("MODIF_TIME not in", values, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeBetween(Date value1, Date value2) {
            addCriterion("MODIF_TIME between", value1, value2, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotBetween(Date value1, Date value2) {
            addCriterion("MODIF_TIME not between", value1, value2, "modifTime");
            return (Criteria) this;
        }

        public Criteria andValdateDateIsNull() {
            addCriterion("VALDATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andValdateDateIsNotNull() {
            addCriterion("VALDATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andValdateDateEqualTo(Date value) {
            addCriterion("VALDATE_DATE =", value, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andValdateDateNotEqualTo(Date value) {
            addCriterion("VALDATE_DATE <>", value, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andValdateDateGreaterThan(Date value) {
            addCriterion("VALDATE_DATE >", value, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andValdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("VALDATE_DATE >=", value, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andValdateDateLessThan(Date value) {
            addCriterion("VALDATE_DATE <", value, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andValdateDateLessThanOrEqualTo(Date value) {
            addCriterion("VALDATE_DATE <=", value, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andValdateDateIn(List<Date> values) {
            addCriterion("VALDATE_DATE in", values, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andValdateDateNotIn(List<Date> values) {
            addCriterion("VALDATE_DATE not in", values, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andValdateDateBetween(Date value1, Date value2) {
            addCriterion("VALDATE_DATE between", value1, value2, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andValdateDateNotBetween(Date value1, Date value2) {
            addCriterion("VALDATE_DATE not between", value1, value2, "valdateDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonIsNull() {
            addCriterion("DELIVERY_PERSON is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonIsNotNull() {
            addCriterion("DELIVERY_PERSON is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonEqualTo(String value) {
            addCriterion("DELIVERY_PERSON =", value, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonNotEqualTo(String value) {
            addCriterion("DELIVERY_PERSON <>", value, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonGreaterThan(String value) {
            addCriterion("DELIVERY_PERSON >", value, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonGreaterThanOrEqualTo(String value) {
            addCriterion("DELIVERY_PERSON >=", value, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonLessThan(String value) {
            addCriterion("DELIVERY_PERSON <", value, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonLessThanOrEqualTo(String value) {
            addCriterion("DELIVERY_PERSON <=", value, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonLike(String value) {
            addCriterion("DELIVERY_PERSON like", value, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonNotLike(String value) {
            addCriterion("DELIVERY_PERSON not like", value, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonIn(List<String> values) {
            addCriterion("DELIVERY_PERSON in", values, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonNotIn(List<String> values) {
            addCriterion("DELIVERY_PERSON not in", values, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonBetween(String value1, String value2) {
            addCriterion("DELIVERY_PERSON between", value1, value2, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andDeliveryPersonNotBetween(String value1, String value2) {
            addCriterion("DELIVERY_PERSON not between", value1, value2, "deliveryPerson");
            return (Criteria) this;
        }

        public Criteria andKgIsNull() {
            addCriterion("KG is null");
            return (Criteria) this;
        }

        public Criteria andKgIsNotNull() {
            addCriterion("KG is not null");
            return (Criteria) this;
        }

        public Criteria andKgEqualTo(String value) {
            addCriterion("KG =", value, "kg");
            return (Criteria) this;
        }

        public Criteria andKgNotEqualTo(String value) {
            addCriterion("KG <>", value, "kg");
            return (Criteria) this;
        }

        public Criteria andKgGreaterThan(String value) {
            addCriterion("KG >", value, "kg");
            return (Criteria) this;
        }

        public Criteria andKgGreaterThanOrEqualTo(String value) {
            addCriterion("KG >=", value, "kg");
            return (Criteria) this;
        }

        public Criteria andKgLessThan(String value) {
            addCriterion("KG <", value, "kg");
            return (Criteria) this;
        }

        public Criteria andKgLessThanOrEqualTo(String value) {
            addCriterion("KG <=", value, "kg");
            return (Criteria) this;
        }

        public Criteria andKgLike(String value) {
            addCriterion("KG like", value, "kg");
            return (Criteria) this;
        }

        public Criteria andKgNotLike(String value) {
            addCriterion("KG not like", value, "kg");
            return (Criteria) this;
        }

        public Criteria andKgIn(List<String> values) {
            addCriterion("KG in", values, "kg");
            return (Criteria) this;
        }

        public Criteria andKgNotIn(List<String> values) {
            addCriterion("KG not in", values, "kg");
            return (Criteria) this;
        }

        public Criteria andKgBetween(String value1, String value2) {
            addCriterion("KG between", value1, value2, "kg");
            return (Criteria) this;
        }

        public Criteria andKgNotBetween(String value1, String value2) {
            addCriterion("KG not between", value1, value2, "kg");
            return (Criteria) this;
        }

        public Criteria andRateIsNull() {
            addCriterion("RATE is null");
            return (Criteria) this;
        }

        public Criteria andRateIsNotNull() {
            addCriterion("RATE is not null");
            return (Criteria) this;
        }

        public Criteria andRateEqualTo(Double value) {
            addCriterion("RATE =", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotEqualTo(Double value) {
            addCriterion("RATE <>", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateGreaterThan(Double value) {
            addCriterion("RATE >", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateGreaterThanOrEqualTo(Double value) {
            addCriterion("RATE >=", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateLessThan(Double value) {
            addCriterion("RATE <", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateLessThanOrEqualTo(Double value) {
            addCriterion("RATE <=", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateIn(List<Double> values) {
            addCriterion("RATE in", values, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotIn(List<Double> values) {
            addCriterion("RATE not in", values, "rate");
            return (Criteria) this;
        }

        public Criteria andRateBetween(Double value1, Double value2) {
            addCriterion("RATE between", value1, value2, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotBetween(Double value1, Double value2) {
            addCriterion("RATE not between", value1, value2, "rate");
            return (Criteria) this;
        }

        public Criteria andOrderIdsIsNull() {
            addCriterion("ORDER_IDS is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdsIsNotNull() {
            addCriterion("ORDER_IDS is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdsEqualTo(String value) {
            addCriterion("ORDER_IDS =", value, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsNotEqualTo(String value) {
            addCriterion("ORDER_IDS <>", value, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsGreaterThan(String value) {
            addCriterion("ORDER_IDS >", value, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_IDS >=", value, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsLessThan(String value) {
            addCriterion("ORDER_IDS <", value, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsLessThanOrEqualTo(String value) {
            addCriterion("ORDER_IDS <=", value, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsLike(String value) {
            addCriterion("ORDER_IDS like", value, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsNotLike(String value) {
            addCriterion("ORDER_IDS not like", value, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsIn(List<String> values) {
            addCriterion("ORDER_IDS in", values, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsNotIn(List<String> values) {
            addCriterion("ORDER_IDS not in", values, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsBetween(String value1, String value2) {
            addCriterion("ORDER_IDS between", value1, value2, "orderIds");
            return (Criteria) this;
        }

        public Criteria andOrderIdsNotBetween(String value1, String value2) {
            addCriterion("ORDER_IDS not between", value1, value2, "orderIds");
            return (Criteria) this;
        }

        public Criteria andFStatusIsNull() {
            addCriterion("F_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andFStatusIsNotNull() {
            addCriterion("F_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andFStatusEqualTo(Integer value) {
            addCriterion("F_STATUS =", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusNotEqualTo(Integer value) {
            addCriterion("F_STATUS <>", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusGreaterThan(Integer value) {
            addCriterion("F_STATUS >", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_STATUS >=", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusLessThan(Integer value) {
            addCriterion("F_STATUS <", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusLessThanOrEqualTo(Integer value) {
            addCriterion("F_STATUS <=", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusIn(List<Integer> values) {
            addCriterion("F_STATUS in", values, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusNotIn(List<Integer> values) {
            addCriterion("F_STATUS not in", values, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusBetween(Integer value1, Integer value2) {
            addCriterion("F_STATUS between", value1, value2, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("F_STATUS not between", value1, value2, "fStatus");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1IsNull() {
            addCriterion("ORDER_MONEY1 is null");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1IsNotNull() {
            addCriterion("ORDER_MONEY1 is not null");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1EqualTo(Double value) {
            addCriterion("ORDER_MONEY1 =", value, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1NotEqualTo(Double value) {
            addCriterion("ORDER_MONEY1 <>", value, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1GreaterThan(Double value) {
            addCriterion("ORDER_MONEY1 >", value, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1GreaterThanOrEqualTo(Double value) {
            addCriterion("ORDER_MONEY1 >=", value, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1LessThan(Double value) {
            addCriterion("ORDER_MONEY1 <", value, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1LessThanOrEqualTo(Double value) {
            addCriterion("ORDER_MONEY1 <=", value, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1In(List<Double> values) {
            addCriterion("ORDER_MONEY1 in", values, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1NotIn(List<Double> values) {
            addCriterion("ORDER_MONEY1 not in", values, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1Between(Double value1, Double value2) {
            addCriterion("ORDER_MONEY1 between", value1, value2, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney1NotBetween(Double value1, Double value2) {
            addCriterion("ORDER_MONEY1 not between", value1, value2, "orderMoney1");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5IsNull() {
            addCriterion("ORDER_MONEY5 is null");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5IsNotNull() {
            addCriterion("ORDER_MONEY5 is not null");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5EqualTo(Double value) {
            addCriterion("ORDER_MONEY5 =", value, "orderMoney5");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5NotEqualTo(Double value) {
            addCriterion("ORDER_MONEY5 <>", value, "orderMoney5");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5GreaterThan(Double value) {
            addCriterion("ORDER_MONEY5 >", value, "orderMoney5");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5GreaterThanOrEqualTo(Double value) {
            addCriterion("ORDER_MONEY5 >=", value, "orderMoney5");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5LessThan(Double value) {
            addCriterion("ORDER_MONEY5 <", value, "orderMoney5");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5LessThanOrEqualTo(Double value) {
            addCriterion("ORDER_MONEY5 <=", value, "orderMoney5");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5In(List<Double> values) {
            addCriterion("ORDER_MONEY5 in", values, "orderMoney5");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5NotIn(List<Double> values) {
            addCriterion("ORDER_MONEY5 not in", values, "orderMoney5");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5Between(Double value1, Double value2) {
            addCriterion("ORDER_MONEY5 between", value1, value2, "orderMoney5");
            return (Criteria) this;
        }

        public Criteria andOrderMoney5NotBetween(Double value1, Double value2) {
            addCriterion("ORDER_MONEY5 not between", value1, value2, "orderMoney5");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ORDER_INSTOCK
     *
     * @mbg.generated do_not_delete_during_merge Wed Jul 12 08:41:20 CST 2017
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}